--DROP VIEW V_PRODUCT_METINFOSETDETAIL;

/* Formatted on 2013/11/14 23:41:07 (QP5 v5.227.12220.39724) */
CREATE OR REPLACE FORCE VIEW V_PRODUCT_METINFOSETDETAIL
(
   INFONAME,
   METINFOSETDETAILID,
   SORTNO,
   PRODUCTID
)
AS
   SELECT d.INFONAME,
          d.id metinfosetdetailid,
          d.sortno,
          p.id productid
     FROM tb_sys_metinfosetmain m,
          tb_sys_metinfosetdetail d,
          tb_sys_product p
    WHERE m.id = d.METIINFOID AND m.id = p.METINFOSETID;
